﻿CREATE PROCEDURE [dbo].[sp_Get_State]
AS
	select MdNumber, State from dbo.ZipInfo 
	WHERE State is not null
	group by MdNumber, State order by State